Copyright: Copyright ® ...


Contents
Financial Wizard Help Contents

Version 1.02

For help on Financial Wizard please select one of the options below. For first time users, select General Overview or Beginners Guide.

General Overview

Beginners Guide

 General Functions

 Special Functions


Contents
Financial Wizard Help Contents

Version 1.02

For help on Financial Wizard please select one of the options below. For first time users, select General Overview or Beginners Guide.

General Overview

Beginners Guide

 General Functions

 Always on Top

 Background Colour

 Clock and Calendar

 Decimal Places

 Errors

 Memories

 Tax Function

 Special Functions


Contents
Financial Wizard Help Contents

Version 1.02

For help on Financial Wizard please select one of the options below. For first time users, select General Overview or Beginners Guide.

General Overview

Beginners Guide

 General Functions

 Special Functions

 Accounting Ratios

 Annuity Functions

 Interest Functions

 General Functions

 Metric <> Imperial Converter

 Payroll Calculator


General Overview

Financial Wizard is a fully featured calculator with business and financial functions. A standard calculator has been combined with many other functions, which has produced a general purpose calculator for all office and home users. These functions range from everyday basic calculations to complex financial functions.

The special functions include:

Accounting Ratios

Annuity Functions

Interest Functions

General Financial Functions

Metric <> Imperial Converter

Payroll Calculator

Financial Wizard also includes several other features to help make work easier:

Always on Top Option

Tax Function


Accounting Ratios

Accounting ratios are split into three sections:

Operating Ratios

Financial Ratios

Investment Ratios


Operating Ratios

These are an indicator of how effectively the company's resources are being used.

For full details of each ratio, click with the right hand mouse button over any of the function buttons.


Financial Ratios

These are an indicator of the financial liquidity of the company.

For full details of each ratio, click with the right hand mouse button over any of the function buttons.


Investment Ratios

These assess the relationships between share prices, earnings and yields.

For full details of each ratio, click with the right hand mouse button over any of the function buttons.


Annuities

This function is split into two sections: annuities and annuities due.

Annuities assumes that all payments are of equal size and are made at the end of each and every period.

Annuities due assumes that all payments are of equal size and are made at the beginning of each and every period.

 Annuities

 Annuities Due

By clicking with the right hand mouse button over any of the functions buttons, a message box will appear which outlines the use of that particular function.


Annuities

This function is split into two sections: annuities and annuities due.

Annuities assumes that all payments are of equal size and are made at the end of each and every period.

Annuities due assumes that all payments are of equal size and are made at the beginning of each and every period.

 Annuities

 Present Value

 Payment from Present Value

 Annual Rate

 Number of Payments

 Future Value

 Payment from Future Value

 Rate on Sinking Fund

 Periods to Accumulate

 Annuities Due

By clicking with the right hand mouse button over any of the functions buttons, a message box will appear which outlines the use of that particular function.


Annuities

This function is split into two sections: annuities and annuities due.

Annuities assumes that all payments are of equal size and are made at the end of each and every period.

Annuities due assumes that all payments are of equal size and are made at the beginning of each and every period.

 Annuities

 Annuities Due

 Present Value

 Payment from Present Value

 Annual Rate

 Number of Payments

 Future Value

 Payment from Future Value

 Rate from Future Value

 Periods to Accumulate Future Value

By clicking with the right hand mouse button over any of the functions buttons, a message box will appear which outlines the use of that particular function.


Annuities: Present Value

Calculates the present value of an annuity. This function assumes that all annuity payments are made at the end of the period.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Annuities: Payment from Present Value

Calculates the annuity payment based on an initial financial outlay. By specifying 12 compounding period per year, assuming monthly payments, this function can be used to calculate mortgage payments. This function assumes that all annuity payments are made at the end of the period.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Annuities: Annual Rate

Calculates the annual interest rate of an annuity. This function assumes that all annuity payments are made at the end of the period.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Annuities: Number of Payments

Calculates the number of annuity payments that must be made to equal the present value of an initial investment. This function assumes that all annuity payments are made at the end of the period.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Annuities: Future Value

Calculates the future value of a specified set of annuity payments. This function assumes that all annuity payments are made at the end of the period.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Annuities: Payment from Future Value

Calculates the annuity payment size that is required to reach a specified future value. This function assumes that all annuity payments are made at the end of the period.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Annuities: Rate on Sinking Fund

Calculates the interest rate that must be attained to reach a future value from a specified period payment amount. This function assumes that all annuity payments are made at the end of the period.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Annuities: Periods to Accumulate

Calculates the number of periods that an annuity must run to reach a specified future value. This function assumes that all annuity payments are made at the end of the period.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Annuities Due: Present Value

Calculates the present value of an annuity due. This function assumes that all annuity payments are made at the beginning of the period.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Annuities Due: Payment from Present Value

Calculates the annuity due payment based on an initial financial outlay. This function assumes that all annuity payments are made at the beginning of the period.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Annuities Due: Annual Rate

Calculates the annual interest rate of an annuity due. This function assumes that all annuity payments are made at the beginning of the period.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Annuities Due: Number of Payments

Calculates the number of payments that an annuity due must run for to equal a specified future value. This function assumes that all annuity payments are made at the beginning of the period.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Annuities Due: Future Value

Calculates the future value of an annuity due. This function assumes that all annuity payments are made at the beginning of the period.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Annuities Due: Payment from Future Value

Calculates the period payment required to reach a specified future value. This function assumes that all annuity payments are made at the beginning of the period.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Annuities Due: Rate from Future Value

Calculates the interest rate required to reach the specified future value in the specified period of time. This function assumes that all annuity payments are made at the beginning of the period.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Annuities Due: Periods to Accumulate Future Value

Calculates the number of periods that an annuity due must run to reach the specified future value. This function assumes that all annuity payments are made at the beginning of the period.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Interest Functions

Interest functions are divided into four sections:

 Simple

 Discount

 Compound

 Conversion


Interest Functions

Interest functions are divided into four sections:

 Simple

 Interest

 Interest Accumulated

 Interest Rate

 Interest Time

 Discount

 Compound

 Conversion


Interest Functions

Interest functions are divided into four sections:

 Simple

 Discount

 Interest

 Effective Loan

 Rate

 Time

 Compound

 Conversion


Interest Functions

Interest functions are divided into four sections:

 Simple

 Discount

 Compound

 Investment Required

 Annual Rate X Compounded

 Periods to Grow Sum of Money

 Years to Grow Sum of Money

 Conversion


Interest Functions

Interest functions are divided into four sections:

 Simple

 Discount

 Compound

 Conversion

 Number of Periods

 Rate per Period

 Effective Rate with Compounding

 Stated Rate with Compounding


Simple Interest

Calculates the amount of simple interest earned on an investment.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Simple Interest Accumulated

Calculates the amount of interest plus the initial investment.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Simple Interest Rate

Calculates the interest rate required to reach the future value (investment plus interest).

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Simple Interest Time

Calculates the time required to reach the future value at the specified interest rate.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Discount Interest

Calculates the amount of discounted interest.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Discount Effective Loan

Calculates the initial investment.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Discount Rate

Calculates the discounted interest rate.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Discount Time

Calculates the time required to reach the specified future value.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Compound Interest: Investment Required

Calculates the initial investment required to reach the specified future value.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Compound Interest: Annual Rate X Compounded

Calculates the compounded annual interest rate associated with an investment.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Compound Interest: Periods to Grow Sum of Money

Calculates the number of periods required for an investment to grow to a specified future value.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Compound Interest: Years to Grow Sum of Money

Calculates the number of years required for an investment to grow to a specified future value.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Interest Conversion: Number of Periods

Calculates the total number of periods in an investment.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Interest Conversion: Rate per Period

Calculates the interest rate for each compounding period.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Interest Conversion: Effective Rate with Compounding

Calculates the effective interest rate with compounding.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Interest Conversion: Stated Rate with Compounding

Calculates the stated interest rate with compounding.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


General Financial Functions

General financial functions are divided into three sections:

 Depreciation

 Financial

 Bonds


General Financial Functions

General financial functions are divided into three sections:

 Depreciation

 Straight Line

 Declining Balance

 Double Declining Balance

 Sum of Years Digits

 Financial

 Bonds


General Financial Functions

General financial functions are divided into three sections:

 Depreciation

 Financial

 Present Value

 Net Present Value

 Future Value

 Payback Period

 Discounted Payback Period

 mu%c

 mu%p

 Bonds


General Financial Functions

General financial functions are divided into three sections:

 Depreciation

 Financial

 Bonds

 Bond Price on Anniversary

 Yield to Maturity Rate

 Duration on Coupon Date


Depreciation: Straight Line

Calculates the amount of depreciation for each period using the straight line method. This amount is the same for all periods being depreciated.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Depreciation: Declining Balance

Calculates the amount of depreciation using the declining balance method. Early periods are depreciated at a greater rate than later ones.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Depreciation: Double Declining Balance

Calculates the amount of depreciation using the double declining balance method. Early periods are depreciated at a greater rate than later ones.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Depreciation: Sum of Years Digits

Calculates the amount of depreciation using the sum of years digits method. Early periods are depreciated at a greater rate than later ones.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Financial: Present Value

Calculates the present value of a single future amount.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Financial: Net Present Value

Calculates the net present value of an investment by assessing the present values of the expected cashflows.

To move from box to box either use the mouse or press TAB. To calculate, enter the figures as required into the dialog box and click on Calculate. The result will then appear.


Financial: Future Value

Calculates the future value of a single payment.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Financial: Payback Period

Calculates the payback period of an investment by assessing the expected cashflows.

To calculate, enter the figures as required into the dialog box and click on Calculate. The result will then appear.

Example Calculation

For help with using this function, enter the following figures as an example.
Number of Periods = 5
Cash Flow 1 = -300
Cash Flow 2 = 150
Cash Flow 3 = 150
Cash Flow 4 = 100
Cash Flow 5 = 100

The answer is 2.
i.e. for these figures, it would take two periods to payback the initial investment.


Financial: Discounted Payback Period

Calculates the discounted payback period of an investment by assessing the expected cashflows. The discount rate must be entered as a decimal.

To move from box to box either use the mouse or press TAB. To calculate, enter the figures as required into the dialog box and click on Calculate. The result will then appear.

Example Calculation

For help with using this function, enter the following figures as an example.
Number of Periods = 5
Discount Rate = 0.1
Cash Flow 1 = -500
Cash Flow 2 = 200
Cash Flow 3 = 250
Cash Flow 4 = 300
Cash Flow 5 = 450

The answer is 2.495.
i.e. for these figures, it would take 2.495 periods to payback the initial investment.


Financial: mu%c

Calculates the mark-up of a product as a percentage of its cost. This functions is particularly useful for all retail outlets.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Financial: mu%p

Calculates the mark-up of a product as a percentage of its retail price. This functions is particularly useful for all retail outlets.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Bonds: Price on Anniversary

Calculates a bond's price on its anniversary.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Bonds: Yield to Maturity Rate

Calculates the yield to maturity on the coupon anniversary date.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Bonds: Duration on Coupon Date

Calculates a bond's duration on its coupon date.

To calculate, enter the figures as prompted on the screen. The result will be displayed on the calculator screen, together with a brief description.


Metric <> Imperial Converter

Click on the Metric <> Imperial Converter item in the View menu to display the Converter window.

By clicking on the combo boxes, different conversions can be selected. Once the required conversion has been selected, enter the figure for conversion or move the scroll bar to the required position. The maximum and minimum values of the scroll bar vary according to the conversion selected. When the Converter window is open, you may click to and from the main calculator by clicking on the required window with the mouse.

Clicking on the Transfer to Memory D panel stores the result of the conversion in Memory D, enabling you to use it in the Financial Wizard for further calculations.

To close the Metric <> Imperial Converter click on the Close button.


1996/7 Payroll Calculator

The Payroll Calculator is set for the 1996-7 financial year, and is capable of calculating National Insurance and Income Tax deductions for the PAYE scheme. To view the calculator, click on the Payroll Calculator item in the View menu.

To operate, enter the tax code, or click for the emergency tax code, and click on the type of National Insurance deduction required. Enter the wages amount and ensure that the earnings period is correct. If not, click on the necessary item in the combo box. Finally, press Calculate to calculate the deductions.

To finish using the Payroll Calculator, click on the close button.

Upgrades for future financial years will be available when new figures are released. For further information please contact Springfield Publishing.

Please note:
1 - Only Class 1 contributions can be calculated.
2 - This is not suitable for calculating company directors' NI deductions.
3 - This calculator uses the non-cumulative method, or Week 1 Month 1, calculations. The calculations is based on how much tax an employee has to pay on a particular pay day with no reference to previous pay and tax figures from previous weeks or months.
4 - The Payroll Calculator is only for use in the United Kingdom.


Always on Top

Selecting this item from the Display menu makes Financial Wizard always stay on top of any other applications which are open. This is very useful when using it with other programs which require constant calculations.

The menu item is checked when the always on top feature is selected.

Pressing CTRL + K also switches this feature on.


Tax Function

The tax function is operated by using the Tax button. To add tax to a number, firstly enter the number and then press +, followed by Tax. To calculate the tax exclusive cost, firstly enter the number and then press -, followed by Tax. The T key on the keyboard can be used instead of the Tax button.

Clicking on the Tax button with the right hand mouse button brings up a message box showing the value which the Tax is currently set to.

To change the tax rate, click on Change Tax Rate in the Display menu, or press CTRL + T. Either type in the new tax rate or use the buttons until the desired rate is shown. The tax rate is stored in memory and will be recalled at that rate when the program is used in future or until it is changed.


Basic Tutorial

Financial Wizard is very simple to use - it is exactly the same as a normal calculator.

Click on any of the buttons or menus in the picture to get an idea of just how easy it is to use.

By following the simple instructions above, you should be able to experiment and make full use of all the available functions.


Background Colour

Clicking on the Background Colour option in the Display menu produces a colour palette. To select a new colour, simply click on the colour required followed by OK. The Financial Wizard background, and that of the Metric <> Imperial converter (if displayed), will change to the new colour.


Clock and Calendar

The calculator display can be changed to show a clock and calendar when the calculator is not being used. To do so, click on Show Clock in the Display menu, or press CTRL + C. To hide the clock, simply click on any button, or select Hide Clock from the Display menu or press CTRL + C again.


Decimal Places

This allows the user to select the degree of precision required, for both decimal places and significant digits. These options are selected by simply clicking on the menu item required.

On starting Financial Wizard, the display is set to two decimal places to assist with financial and business calculations. The display is reset to two decimal places when any of the financial functions are selected.


Errors

If a calculation is attempted which is outside the range of the calculator, or if there is an error in the input, a message box is produced to give you some idea of what has happened.

A Function Error will occur if you press the cancel button of a function input box.


Memories

Financial Wizard is equipped with four memories, labelled A to D. These operate in the standard way by using the M in key to enter a number into the memory, and M rcl to recall it later. The M + key is used to add the current display to the value already held in the memory

To select a different memory, simply click on the option button required. Double clicking on an option button produces a message box displaying the current value of that memory.

All memories can be cleared by selecting Clear Memories from the Display menu, or by pressing CTRL + M. You will then be asked to confirm this operation before proceeding.


BASICDISPLAY
Display Menu

To change the set-up of Financial Wizard, select the required item from this menu.


BASICFILE
File Menu

To exit Financial Wizard, simply click on Exit.


BASICHELP
Help Menu

To obtain help when using Financial Wizard, click on Contents or Search for Help on.


BASICVIEW
View Menu

To select any of the special function screen, click on the set of functions required. To shrink the calculator back to its original size, click on Basic Calculator.


GENERALDISPLAY
The Display

Any actions performed will be displayed here. The display can also be made to show a clock and calendar.

Clock and Calendar


GENERALENTRY
Performing Calculations

Financial Wizard acts as a standard calculator. Use either the keyboard or click on the buttons with the mouse. Type C for Clear, and E for Cancel Entry.


P1
Enter the tax code here. Place the digits in the left hand box and the letter in the right hand box.


P10
This display the tax allowance for this earnings period.


P11
This display the tax payable for this earnings period, as denoted by the combo box.


P12
Click here to calculate deductions based on the figures given.


P13
Click here to close the Payroll Calculator


P2
Click here to select the emergency tax code.


P3
Enter the amount of gross wages here.


P4
This displays the wages after National Insurance and Tax has been deducted.


P5
Click on the combo box to select the relevant earnings period, i.e. for how many weeks this amount of wages covers.


P6
This display the Employee's Primary contribution) NI sum payable for this period.


P7
This display the Employer's (Secondary contribution) NI sum payable for this period.


P8
Click on the required option button to select the correct rate of National Insurance.


P9
This display the tax allowance for the financial year as a whole, calculated from the tax code.